UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '9tDNtD7ZSGEich+U8piVLfe1TznLq2kddnT75GH+AjM='
WHERE
key_id = '462011a8a433f7ffe193409c805924ee20fff3a74938578771f513472ec393dc'
AND (
token = '9tDNtD7ZSGEich+U8piVLfe1TznLq2kddnT75GH+AjM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)