UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XOJkR8qDI6cyLkvd5tdzIg0gnIdZA+FMvHJ7MLVCv5g='
WHERE
key_id = 'b39d3d2eea804d9da7b431fefee3ab3c48ecfa06295d5fb4ea7468fc93dfdf98'
AND (
token = 'XOJkR8qDI6cyLkvd5tdzIg0gnIdZA+FMvHJ7MLVCv5g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)