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