UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'zurg8KoUsKhLpJ49hzDJlP+4q3YgRJ76704byZUrmRA='
WHERE
key_id = 'ce9a4ad31c92ac605db68811fffc8d3308d1aa519416b7adc1e3b712c1835337'
AND (
token = 'zurg8KoUsKhLpJ49hzDJlP+4q3YgRJ76704byZUrmRA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)