UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p6Sh83idAwxy51t9WEfwbcnvVT+XwaUgImks+H449Gg='
WHERE
key_id = 'a0eadeea3db8dec76891bd47b47d5be3579ed3ab2b64ed243771d9a6009d2719'
AND (
token = 'p6Sh83idAwxy51t9WEfwbcnvVT+XwaUgImks+H449Gg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)