UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'VpagwDnjdNXpLgwJq5QfRPOxTgv0/6cI8i3Qmqmhscg='
WHERE
key_id = '6ab8b7835d2180d8e8cb1708aa8f62c4da4baf0828591dc7357467caae80cd51'
AND (
token = 'VpagwDnjdNXpLgwJq5QfRPOxTgv0/6cI8i3Qmqmhscg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)