UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'z+3WWrxff6oFZrcEebFOpfsaKrq8/fka7I7pMyqIVdU='
WHERE
key_id = 'c67be208d187c41b7ec00b913bdb6c50b69a51b616a6995da83077d278f51d70'
AND (
token = 'z+3WWrxff6oFZrcEebFOpfsaKrq8/fka7I7pMyqIVdU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)