UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2W7HGuBRInJxJZxOhDeeIz7m21wgzrEcpbkOKowUiZQ='
WHERE
key_id = '7b292151202f2da46ed30cb2caa0fb429418bc0a62101a51f7c215b44854c14f'
AND (
token = '2W7HGuBRInJxJZxOhDeeIz7m21wgzrEcpbkOKowUiZQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)