UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'BHU+Lp4r2KxvzWaZSmJwYGe5QN4AoS6Fh3YU6Y0aMPs='
WHERE
key_id = '565dafd09813876021154ca528da13294491c85d52b2d80a8b1adbc9cef129d3'
AND (
token = 'BHU+Lp4r2KxvzWaZSmJwYGe5QN4AoS6Fh3YU6Y0aMPs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)