UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0MT6JbkFSOHCms4nq0W77wSjncNTjpG5zD1nCbIw9YE='
WHERE
key_id = 'abde78d3ec2139d2bfff58aa03e0f99f3d8a409e843ffc5d265584bd86c8a345'
AND (
token = '0MT6JbkFSOHCms4nq0W77wSjncNTjpG5zD1nCbIw9YE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)