UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'QphyrEAHulJZjlkAEbvceuP+aKVmW2rCIqe4hXqAcs0='
WHERE
key_id = 'f1d14f0017e2d87b3142e6df785620dc0b43927918bacd8aa8e9df623038f9a6'
AND (
token = 'QphyrEAHulJZjlkAEbvceuP+aKVmW2rCIqe4hXqAcs0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)