UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C2XOMYxir13oAxv059/ISbZLukQvT0vgm8N3jFYaExo='
WHERE
key_id = 'e13473f55db4fd2a8e28a74daa3d9988a1e70e4d70513fe99bd9b8be54204776'
AND (
token = 'C2XOMYxir13oAxv059/ISbZLukQvT0vgm8N3jFYaExo='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)