UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'X1YGw88BserfADRVY84zCS3h6zXk86ebfXQcFHKUeXE='
WHERE
key_id = '843c0195e50762b6b5389e6a4c4cf523d847305d5f0bbb8e0c6f6407abf953b0'
AND (
token = 'X1YGw88BserfADRVY84zCS3h6zXk86ebfXQcFHKUeXE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)