UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/yQXPTgxkhzIs/FF9Z4UaOjLrUruaXfJYkHgp2YrweE='
WHERE
key_id = 'ddaa9b934dde0a0a9f85f294c7caa2c475ba7ef95f1250bfa944067a62c46333'
AND (
token = '/yQXPTgxkhzIs/FF9Z4UaOjLrUruaXfJYkHgp2YrweE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)