UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'k2D9c3YgUj7dUaNvhrnc0F6lbu9lnH1i/QfS0VO6eto='
WHERE
key_id = '27c7233c54239c735082fbb542b9ce79617fd15d41e6571f55e10efbead4a61f'
AND (
token = 'k2D9c3YgUj7dUaNvhrnc0F6lbu9lnH1i/QfS0VO6eto='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)