UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Tz2qxWI2pfJvQDA4McfaNLg41I/Wzg8mExiMytF8smY='
WHERE
key_id = '650711a765fb0206de7c1606671992e8b8c0a97025de2a58af9e72f14f52d0e7'
AND (
token = 'Tz2qxWI2pfJvQDA4McfaNLg41I/Wzg8mExiMytF8smY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)