UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'RHYSwwc8An8KGeH4qjQ4ysGAQ12yb2euwmgSQMRjUso='
WHERE
key_id = 'd6aeef5397e2b2c2953241bf496c75909c6a35ab9d53b39c3a88b6cd4c8a6b38'
AND (
token = 'RHYSwwc8An8KGeH4qjQ4ysGAQ12yb2euwmgSQMRjUso='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)