UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W7waAO/J/neh+b1W4G8AsnoutfhBzV0lF5a5WQwXAAM='
WHERE
key_id = '7c9634f7996358c14c98b249df48e109e28e3f70176deb986b918096406db88b'
AND (
token = 'W7waAO/J/neh+b1W4G8AsnoutfhBzV0lF5a5WQwXAAM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)