UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gbogNWQHwWA2IkZ/E3xJKx5ii24E9gnSTWUl6JncFfc='
WHERE
key_id = '63c40f61589fc64666c08ebbb89b94d7406d645510b51e40cd258bc934ebfadd'
AND (
token = 'gbogNWQHwWA2IkZ/E3xJKx5ii24E9gnSTWUl6JncFfc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)