UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gJy0xvPjzaG3zgjH0KfvFJvfl2GKm9Nj6WmG9yIzf1w='
WHERE
key_id = '2345224193d87f5051e1461fd5ce784a72800d957525949174157a032288b2e5'
AND (
token = 'gJy0xvPjzaG3zgjH0KfvFJvfl2GKm9Nj6WmG9yIzf1w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)