UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'D6ucdgCLXbYdGKDY8Srxcka2GIE4FPUQgr505SjdlCc='
WHERE
key_id = 'a480a02a57e348e623414f7e6bb22816921341f6823a3c9fa329a245f2d4accb'
AND (
token = 'D6ucdgCLXbYdGKDY8Srxcka2GIE4FPUQgr505SjdlCc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)