UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SZUBIRQ0q6TRv67rtiwtgVf4cu6U60rgAUmq2nBNM8o='
WHERE
key_id = '7e79918c0b4c309510ed1f8e516328a139180fd8b3cd1c379c2e9879d64a78a0'
AND (
token = 'SZUBIRQ0q6TRv67rtiwtgVf4cu6U60rgAUmq2nBNM8o='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)