UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MBctDBxrQP38ivUWDQNUxWTp3DDDBrm4vflnRb46+d0='
WHERE
key_id = 'c131a400afc00cdfc059d030c6ae9c86db78f2c157909edeeb32ea7c6797cfee'
AND (
token = 'MBctDBxrQP38ivUWDQNUxWTp3DDDBrm4vflnRb46+d0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)