UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7UbS3lWnEnjZL/J+S7U+FFuCoEvIhnJGajd+4xKwfrU='
WHERE
key_id = 'ebd80258f17c7e91e38920194eccf0c7616aa8372acc978e04cf0bf7d304ee86'
AND (
token = '7UbS3lWnEnjZL/J+S7U+FFuCoEvIhnJGajd+4xKwfrU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)